How to store table values in order
Without an ORDER BY clause, you have no guarantees as to the order the rows are presented to you, even if they 'look' ordered when you run a select.  Bullet 1 of this link

https://msdn.microsoft.com/en-us/library/ms188385.aspx