A service of thanksgiving will be held at St Giles' Cathedral in Edinburgh to mark his Coronation.