title: sql select default order
body: <p>So I have this sql request (to select products by external ID):</p>
  
  <pre><code>SELECT p.product_id, p.external_id 
  FROM oc_product p 
  LEFT JOIN oc_product_description pd 
      ON (p.product_id = pd.product_id) 
  LEFT JOIN oc_product_to_store p2s 
      ON (p.product_id = p2s.product_id) 
  WHERE pd.language_id = '2' 
      AND p.status = '1' 
      AND p.date_available &lt;= NOW()
      AND p2s.store_id = '0' 
      AND p.external_id IN ( 38291, 21472, ... ,10)
  LIMIT 0,20
  </code></pre>
  
  <p>It returns me list of id's:</p>
  
  <p><a href="https://i.stack.imgur.com/CQ023.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CQ023.png" alt="enter image description here"></a></p>
  
  <p>The order of returned list is ASC. but I want that order would be the same as I wrote external_ids in query. (38291,  21472, 21473, 35229, 35030,  ...)</p>
  
  <p>Any idea how to do that?</p>