Use Save a Copy As to save a clone of your file.
Sort the records in your original file into the order that you want.
Open the clone and import the records into the clone.
Discard the original file and keep what was originally your clone but which now has records whose unsorted order matches the order you want as the automatic order. Please note that new records will not automatically appear in this order.