A memorial service will take place at St Giles' Cathedral in Edinburgh to mark the 25th anniversary of the 9/11 terror attacks.