Duke of York and George Osborne were among the 1,000 guests at a moving commemoration service at Manchester Cathedral