Opposition parties have given the Brexit border agreement a cautious welcome, warning that the next phase of talks will be “economically critical” for Ireland.