You can automate this using the in-game programing language, but yes it does require a mod (kOS). I'm assuming/hoping that KSP2 has something similar in vanilla.

It's straightforward though, the documentation is here:

https://ksp-kos.github.io/KOS/structures/vessels/stage.html