A man has been seriously injured in an explosion at a home in Yorkshire - with a neighbour saying the blast had "sounded like a bomb going off".