Base table shows records in a strange order

I have an .odb that is the frontend for a MySQL database. Is there a way to force the tables to order by the primary key when I open them in Base?

Add a simple query:

SELECT * FROM "table" ORDER BY "primary_key"

If dealing with Table Data View then they open in the method last sorted in:

Screenshot at 2021-12-28 08-46-20

So just sort on your primary key column:

Screenshot at 2021-12-28 08-47-35

Then save Base file when closing. Sort sequence will remain as last selected.

Perfect! Just what I was looking for.