The leader of Southampton City Council has admitted she holds a “long-standing opposition” to Right to Buy.