Reunification of Ireland and the future status of Scotland are issues “definitely on the table” as a result of Brexit, the former head of the UK Foreign Office and Diplomatic Service has said.