2
You can't make any assumptions about the order in which data is stored in the database. If you want to retrieve data in a certain order, you have to use an ORDER BY clause when you retrieve the data, e.g.
SELECT x,y,z FROM table ORDER BY z ASC
or
SELECT x,y,z FROM table ORDER BY x ASC, y DESC