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?