[release] Automate input of release versions on prepare release workflow

[mx-psi]

Component(s)

No response

Describe the issue you're reporting

We have to manually input versions when running the prepare release workflow. We could instead specify whether we want to bump minor (default) or bump bugfix for each module set. This reduces the amount of manual steps that we need to do.

We already automate it on the Collector releases repository https://github.com/open-telemetry/opentelemetry-collector-releases/blob/ce900446e8df967f7f7fbe2ef791d985334dda97/.github/workflows/scripts/bump-versions.sh#L113-L122