Add upgrade guide for PhysicalOptimizerRule::optimize_plan

[alamb]

This PR changes the commonly used public interface and deprecates methods. Should we at least mention the change in the upgrade guide?

Originally posted by @milenkovicm in #18739 (comment)

[adriangb]

I opened #19030