Let's say we have a table with an id (which is auto-incrementing index). Let's then select some rows from this table-- nothing fancy, just simple selection. Can we assume that the rows are returned in the order defined by id, and not in some random fashion.
We could employ "order by id asc" but I think that forces a temporary result table to be built (?) and would slow down the result set.