It is against California State law for them to rent a car to you unless they provide minimum liability insurance. Most car rental places self insure state mandated minimum liability.
IMO Scam for sure on the part of the counter person. I'm sure there must be some kind of commission or quota for up selling additional coverage involved.