Cardinal Roger Mahony, leader of America’s largest Roman Catholic archdiocese, apologised to the hundreds of people who will get a share of a €488m settlement over allegations of clergy sex abuse.