Depends on the state on the table being inserted into.

If it is a new table, temporary or truncated, the inserted records will be in order.

If the table has already been...