Dramatic footage shows the moment a group of young kayakers needed rescuing after being swept out to sea during a school water sports trip.