Support Prisma v6

[AbhiPrasad]

Description

From: getsentry/sentry-docs#12184

Prisma launched new version of 6.1.0 where tracing is not in previewFeature and some additional things need to be done to be able to trace application. Docs need to be updated

https://github.com/prisma/prisma/releases/tag/6.1.0

On our side we've been evaluating merging in #14624 for v9 (considering it seems to be a breaking change in some ways).

We need to figure out:

1. Can we merge in 6.x bump for prisma instrumentation and still support 5.x? Ideally we can figure out how to support both at the same time so we support the max amount of users.
2. How do we structure the docs (this issue: Outdated prisma documentation sentry-docs#12184) to make both 5.x and 6.x of the prisma integration work with 8.x and 9.x of the SDK.