How SQL decide to return which records when I execute the following qu

Hello
How SQL decide to return which records when I execute the following query in my terminal? Is it randomly?

SELECT * FROM users LIMIT 100;

note: I did not use ORDER BY in my query.

A little bit about why I am asking this question: I just think how SQL store data. Does it save inserted data ascending based on createdAt?