Germany has apologised for its role in the slaughter of Herero and Nama ethnic groups in Namibia more than a century ago.