I think the better approach would be for the manager to share something themselves, to demonstrate that a bit of vulnerability is okay, but not even ask if anyone else wants to say anything and certainly not make people feel they should. In other words lead by example so that if someone feels like they want to open up they can and their manager will be supportive.