Donald Trump’s plan to erect a huge sea wall at his Irish golf course has been withdrawn in the light of stiff opposition.