The only way to ensure that a query returns results in the order that you want is to have an ORDER BY.

select * from TableA order by col3