Diplomat who worked on Bloody Sunday dossier speaks of ‘exhilaration’ at families’ reaction to apology