I remembered that some old functional phone has such compatibility. Their alarm will ring no matter your phone is off or on. Being totally independent to the phone function.
I‘m pretty sure all Nokia phones did that.
I had a Sony (Android 4?) that could do that. Such a useful feature.