A Scottish cardinal who resigned after being accused of sexual improprieties has reportedly been asked by the Vatican to leave the country.