The appointment of Peter Mandelson as the UK Ambassador to the US is a ‘huge opportunity for Northern Ireland’, the deputy First Minister has said