Large parts of Mexico Beach, Florida have suffered "unimaginable destruction" after the third-strongest hurricane in US history slammed into the sunshine state.