For example, on a 4-port non-powered USB 3.0 hub,
This example is ambiguous. There are two kinds of "a non-powered" hubs, aka "bus-powered" hubs.
(1) The certified ones would have a special logical switch if plugged without external AC-DC adapter, and report to host as being "bus-powered", with an information on how much the hub silicon consumes itself.
(2) Hubs that fake their descriptors and falsely report themselves as "self-powered" hub, no matter with AC adapter or without.
In case (1) the host will make note of hub being bus-powered, and of its own power needs. Then, when sequentially enumerating devices from Port1 and so on, the host will read the device nameplate requirements, and check it against available port power budget of 900 mA. If the total doesn't exceed 900 mA, first device will be allowed to connect and operate. The same will happen with a device connected to Port2, etc, until the upstream (host) port budget is exhausted. The next attached device won't be allowed to operate. (Note: this USB 3.0 power budget schema is more elaborate than in USB 2.0, where a bus-powered hub would allow only under 100 mA devices per each port, no matter if all other ports may consume nothing).
In case (2) all devices will be allowed to connect, but the delivered power will likely sag (and cause hub malfunction and/or unstable operation), or host port would trigger its overcurrent protection, or cable might smoke out. You choose.
Your question asks about power but the limits you mention are for current. USB can supply various voltages in practice. – Turkeyphant – 2019-07-16T10:10:35.103
@Turkeyphant I don’t think so. USB-C excluded, there’s 5 V and that’s it. This question is about USB as a data connection. – Daniel B – 2019-07-16T11:46:04.697
Firstly, USB type-C is a connector not a spec and nothing in the question says it's about data only. I know some USB ports put out 9V but I don't know whether they comply to USB 3.0. – Turkeyphant – 2019-07-16T16:17:39.653
USB-C most certainly has a spec, especially because it is much more than just a different physical USB connector. No compliant USB port would ever output 9 V, not even with USB-BC or USB-PD. // Because the OP started out with 900 mA, it’s safe to assume this question is about “plain old USB”. – Daniel B – 2019-07-17T12:33:39.293