MySQL queries are not getting ordered correctly

[zameel7]

Trying to query a single table using MySQL connector. Order by was used on the column id and the rows were ordered based on different values. For eg:

I tried these variations, and the final query with more than two columns got ordered correctly, but the same order is shown by default even when I don't use the order_by condition.