Some of this comes down to cost optimization.

I believe Firebase charges per record returned. Having an index and sort query doubles the costs compared to client side sorting on the index.