Rise and fall of post-starburst galaxies in Magneticum Pathfinder