The vast majority of farmers are opposed to a state visit to Ireland by US president Donald Trump, with an opinion poll also finding a majority of rural dwellers believing he will damage America’s global standing.