More than half of voters in Northern Ireland believe the UK should rejoin the European Union a decade after the Brexit referendum, a new opinion poll has suggested.