A man has been found dead among the debris of a Nottinghamshire house that was destroyed by a “gas explosion”, police said.