SELECT `e`.* FROM `catalog_product_entity` AS `e` WHERE (`e`.`entity_id` IN('2841', '2850', '2922', '3061', '3077', '3101', '3151', '3157', '3162', '3176', '3189', '3452', '3727', '3728', '3738')) ORDER BY FIELD(e.entity_id, 2841,2850,2922,3061,3077,3101,3151,3157,3162,3176,3189,3452,3727,3728,3738), `e`.`entity_id` asc
<pre/>2841 - Gi Product 4
2850 - New ODOP Pro1
2922 - Test 0969
3061 - Kurta multi
3077 - New ODOP Product0126
3101 - Testpr multi 
3151 - shwals gi odop
3157 - Multi Kurtas 1
3162 - Gi Odop Simple product
3176 - Test Multi  color product (English)
3189 - Kurta pajama set multi odop gi
3452 - Kurta payjama set multi
3727 - kurta m 
3728 - Shwals  simple pr Self
3738 - New Shwals Wrh simple