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