Scottish cardinal resigns after sex accusations