[C++] Register the new Opaque extension type by default

[jorisvandenbossche]

The Opaque extension type implementation for C++ (plus python bindings) was added in #43458, but it was not registered by default, which we should do for canonical extension types (see #43458 (comment))

[rok]

Issue resolved by pull request 43788
#43788