Police have found the body of a man following an explosion which caused a house to collapse in Andover.