Dynamic coexistence driven by physiological transitions in microbial communities