The man, thought to be a 49-year-old from Scotland, got into difficulties around 11am today at Cala d’Or, a resort area on the southeast coast of Majorca