The incident happened at S’Arenal Gros beach in Portinatx in northern Ibiza, with off-duty emergency services workers trying their best to save the woman