thanks Paul.
here is how it sorts today:
if using bluesky relay as source, the order is roughly when the relay first saw the record in that collection.
(one caveat though, it doesn't account for deletions)
lightrail (default) handles deletions but sorts by DID instead