Cardinal Keith O'Brien apologises for sexual misconduct