title: SQL Server Select query with IN() and order by the same
body: <p>I need a <code>SELECT</code> query with an <code>IN</code> clause, as well as <code>Order by</code>:</p>
  
  <pre><code>select * 
  from table 
  where column_id IN (5,64,2,8,7,1) 
  </code></pre>
  
  <p>This code returns <code>1, 2, 5, 7, 8, 64</code>.</p>
  
  <p>Now I need to return the same select in order</p>
  
  <p>Output needs to be:  <code>5, 64, 2, 8, 7, 1</code></p>
  
  <p>In Mysql, field option is there, but SQL Server does not have such a field option.</p>