Footage has emerged of a tornado flipping a car onto its roof in South Carolina as Hurricane Idalia sweeps across the US east coast.