How to store table values in order I created a table and inserted values into it but they are not storing in orderly manner.
The table looks like:


I can order them by using ORDER BY but it does not change them permanently. Is there a way to save them in orderly manner permanently.

Clarification: I don't want how they are stored internally, what I want is when ever I execute select * from cricket; the results to come sequentially. So that I don't want to use ORDER BY clause every time. Is there a way?
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