At least ten people have been killed and 12 remain missing after torrential rain caused flash flooding on the Spanish island of Mallorca last night.