The Duke of Cambridge spoke about pain and trauma at the opening of a memorial for victims of the 2017 terrorist attack at Manchester Arena.