Formula and API results display records in “reverse” order compared to the visual user inteface


I found a somewhat similar thread in the Support forum (Reordering Link to Another Table column items), however I think this is substantively different.

If I were to ask a user to manually order linked records by some criteria, they would intuitively place the “first” records at the top (or left) because that’s visually “first”. However, when fetching results via a formula or via the API the first record returned in the array is the “bottom” or “right” most record—what I think is the “last” record.

I understand that the newest record entered “pushes” the other records down/over. I don’t really have an issue with that. It’s just that I can’t think of any reason why the formula/API would show the last record first.