ci: add workflow to raise a PR to Operator Hub community and prod repos

[github-actions[bot]]

Thanks for making a pull request! 😃 One of the maintainers will review and advise on the next steps.