I want to opt-in to deposit limit. Will it apply instantly?

Yes, it will be applicable instantly.