A harrowing scene unfolded along a Mexican beach as drone footage captured swimmers becoming swamped by a huge wave in the wake of Tropical Storm Alvin.