I think this is a convenient side-effect of the implementation which was later turned into official behaviour. A bit like Python dictionary key ordering.
In Postgres you can do similar things with a DISTINCT ON query.
I always found this one of the hardest simple things to do in SQL.