How to sort by primary key only?

Question

SQL

There is a table, it has a primary key on a digital field and a unique index on the title (Text).
After an arbitrary selection, IDs do not go in ascending order, but it is not clear how.
As I understand it, sorting is also performed by the text field ... Is it possible somehow to sort only by the primary key without using order by, or with this combination, you will always have to do a forced sorting of the results?

Answer 1

The order of SELECT results is not deterministic without the explicit use of ORDER BY.

Answer 2

and why order by by primary key is bad?

Answer 3

Yes, it is necessary to specify explicitly always sorting.