Most of the time you will get the order in which the rows were inserted, unless you use indexes.
It is however not 100% garantueed that you will always get the same order.
Conclusion: order does not matter. If it does, use ORDER BY.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP