Vincent,
I can't really comment on why the decision was made, but I can add some context and opinion. The RTDB push IDs are not exactly "sequential". They are based on the current time, as measured by the client device. In general, this means that the IDs sort in chronological order. However, this breaks down in two cases. 1) When the client's clock is wrong, and 2) the client was offline at the time the ID was generated, then synchronized later. In both cases, you could observe that nodes could appear "out of order", significantly breaking the sequence that you might expect, since new records could very easily appear anywhere in the list. (Also, malicious clients could easily fake this value.)
With Firestore, if you want time-based ordering based on the server's sense of time, I'd recommend using a timestamp type field, and have the client pass
FieldValue.serverTimestamp() to it. On top of that, I'd add a security rule that requires this to be the case, so that clients can't possibly send some other date. Then, you can query the data using that field explicitly, rather than depending on data "hidden" in a push ID, since that's subject to inaccuracies on the client.
You can still use the RTDB push IDs if you want. But personally, I would try to abandon the idea of sorting things based on the ordering of the hidden times in push IDs.
Doug