Disgraced Cardinal Keith O’Brien should stay away from Scotland for the good of the Catholic Church, according to his successor.