Seems like the newbies early in their careers would benefit more from the office so they can learn the world of work and company culture. Managers and executives would also work from the office to teach them, and because they're the only ones so excited about the return to office. Everyone else could work remotely, because that makes the most sense.
I couldn't agree more with @1uzv+1jmJwSPu. This sounds like the perfect solution!