SELECT Id, Name FROM User LIMIT 10
It generates list of 10 users in some order randomly. On what basis does Salesforce give these 10 records? Ordered by CreatedBy ASC? DESC? Name ASC? DESC? But no, it doesn't satisfy any of these conditions!!
But to my surprise every time I execute this, I get the same results. So, there must be some default ORDER BY. Can anyone please let me know!