The former Manchester United and Scotland forward was laid to rest at Manchester Cathedral.