Enable CMIS host mgmt. feature to Mellanox-SN4700-O8C48, Mellanox-SN4700-O8V48 SKUs

[noaOrMlnx]

Why I did it

To enable CMIS host mgmt feature

Work item tracking

• Microsoft ADO (number only):

How I did it

N/A

How to verify it

Make sure CMIS host mgmt feature is enabled

Which release branch to backport (provide reason below if selected)

• [ ] 201811
• [ ] 201911
• [ ] 202006
• [ ] 202012
• [ ] 202106
• [ ] 202111
• [ ] 202205
• [ ] 202211
• [ ] 202305

Tested branch (Please provide the tested image version)

• [ ]
• [ ]

Description for the changelog

Link to config_db schema for YANG module changes

A picture of a cute animal (not mandatory but encouraged)

[keboliu]

and also please update the media_settings and optics_si_settings file.

[noaOrMlnx]

@keboliu Feature in sai.profile is already enabled. Regarding the media_settings.json update request, disucssed internally and found a solution. will apply soon

[noaOrMlnx]

/azpw run Azure.sonic-buildimage

[mssonicbld]

/AzurePipelines run Azure.sonic-buildimage

[azure-pipelines[bot]]

Azure Pipelines successfully started running 1 pipeline(s).

[noaOrMlnx]

/azpw run ms_conflict

[mssonicbld]

/AzurePipelines run ms_conflict

[azure-pipelines[bot]]

No pipelines are associated with this pull request.

[noaOrMlnx]

Azure-Pipelines-Wrapper / ms_conflict

[noaOrMlnx]

/azpw ms_conflict

[noaOrMlnx]

/azpw ms_conflict

[noaOrMlnx]

@yxieca can you please cherry-pick to 202311?

[mssonicbld]

Cherry-pick PR to 202311: https://github.com/sonic-net/sonic-buildimage/pull/19055