Prometheus exporter handles instrumentation scope and prevents collisions

Now that https://github.com/open-telemetry/opentelemetry-specification/pull/2703 is released, we can update the prometheus exporter to make use of OpenTelemetry scope, particularly for reducing collisions between metrics with the same name.

Describe the solution you'd like

There are a few components:

• Add otel_scope_name and otel_scope_version attributes to all metrics based on the instrumentation scope name and version.
• Add an otel_scope_info metric following https://github.com/open-telemetry/opentelemetry-specification/blob/main/specification/compatibility/prometheus_and_openmetrics.md#instrumentation-scope-1.
• Prevent collisions between TYPE, HELP, and UNIT comments following https://github.com/open-telemetry/opentelemetry-specification/blob/main/specification/compatibility/prometheus_and_openmetrics.md#metric-metadata-1

Note that the exporter SHOULD do the above by default, but may allow disabling the behavior.

Start by locating the Prometheus exporter in the opentelemetry-python repository and read the linked OpenTelemetry compatibility sections on instrumentation scope and metric metadata. Verify how instrumentation scope is currently represented, then implement the requested scope attributes, otel_scope_info metric, and collision prevention. Done means all three behaviors follow the specification by default, with any disabling option documented and tested.