title: Identity column and using order by in query
body: <p>I use SQL Server 2008 R2 and have a table with an <code>id</code> column as <code>identity(1,1)</code>. If I want to get query ordered by id column, do must use <code>Order By ID</code> or not necessary. </p>
  
  <p><strong>EDIT :</strong>
  I have a unique clustered index on ID column. do this index guaranteed that my query sorted by id by default.</p>