[Components][SN74HCxx5 I/O Expander] Add possibility to work on same GPIO pins

**Describe the problem you have/What new integration you would like**

The development boards [Dingtian Relay Development Board](https://github.com/dtlzp/relay_dev_demo) with number of relays/inputs, more than 4 are using SN74HC165 & SN74HC595 I/O Expanders, sharing same GPIO except "data" pin
Please check this 8x I/O board GPIO mapping:
The current SN74HCxx5 driver implementation doesn't allow to define them simultaneously, only OR-OR. Being defined together, none is working.

Can you please modify it to allow this scenario?

**Please describe your use case for this integration and alternatives you've tried:**

**Additional context**

Start with the SN74HCxx5 driver implementation and the GPIO mapping shown for the linked 8-channel board. Confirm how SN74HC165 and SN74HC595 instances currently reject shared GPIO definitions, then define the expected simultaneous configuration and verify that both expanders operate while sharing GPIO pins other than data.

Written by the indexing model from the issue text.