Once expansion unit ID’s are set, do they need to be connected in order?

No. It does not matter which order you connect the expansion units to the CPU. All that matters is they must have unique ID settings.