Enable merge queue on this repository

[mx-psi]

We have wanted to enable a merge queue in opentelemetry-collector-contrib for some time now. To test it out first and remove any wrinkles, we want to roll this out on smaller repositories like opentelemetry-collector-releases first. To do that we would need to?:

1. File a PR like [chore] Add build-and-test, build-and-test-windows, changelog and telemetrygen to merge group opentelemetry-collector-contrib#31162 on this repository
2. File an issue on the community repo similar to this one: REQUEST: Repository maintenance on opentelemetry-collector-contrib community#1936

[ArthurSens]

I'm looking at the docs and the example you provided now. For this repository, do I understand correctly that all workflows in this folder should be added to the merge queue? Or is there any workflow that we can ignore?

[mx-psi]

@ArthurSens I think for this repository anything with a trigger on pull requests or pushes to main should be in the merge group as well. So for example this one should not be added and this one should not be added either since they are triggered manually/with a tag push

[mx-psi]

Will close when open-telemetry/community/issues/2457 is done

[ArthurSens]

And now this one should be good to close as well :)