Thanks Minesh.
So it seems a solution for the default TwentyTwentyThree theme.
Because I am using another block theme Spectra One, it is a bit more complex.
You can get in touch with Spectra theme support and check with them how you can use PHP template for your custom post type and they will guide you accordingly and if you have working solution, you're welcome to share here for the benefit of other users.