I want to opt-in to spending limits. Will it apply instantly?

Yes, it will be applicable instantly.