Tracing: Adopt OpenTelemetry error.type attribute for logical calls

[lmolkova]

Library name

Azure.Core

Please describe the feature.

OTel defined error.type attribute we can use to report low-cardinality failures with.

We can just add it in

azure-sdk-for-net/sdk/core/Azure.Core/src/Shared/DiagnosticScope.cs

Line 143 in 2b941a2

public void Failed(Exception? exception = default)

public void Failed(Exception? exception = default)
{
    if (exception != null)
    {
        AddAttribute("error.type", exception.GetType().FullName);
    }

    _activityAdapter?.MarkFailed(exception);
}

(as long as it does not conflict with HTTP-level error.type we're going to set in #39429)