title: How to order by where in fields in Laravel
body: <p>I did some calculate in a view table for products in MYSQL, so I list these id for product reference id.</p>
  
  <pre><code>$referenceIds = viewTable::orderBy('score', 'DESC')-&gt;lists('product_id');
  </code></pre>
  
  <p>And I want to get the product from those reference id.</p>
  
  <pre><code>$products = Product::whereIn('id', $rederenceIds);
  </code></pre>
  
  <p>The product content is correct, but the order is wrong, how to load product order by reference id, I know I can do it in MySQL by using <code>ORDER BY FIELD(id,' . $fields . ')</code>, but I want to find out Laravel way, and hope not use <code>ORDER BY FIELD</code> command because it seems waste to much database efficiency.</p>