Quick Answer
Supported Xbox hardware
The official listing targets Xbox Series X|S. Search results for The Sinking City can easily surface the first game's separate Series X|S release, which has a different store identifier and should not be used as evidence for sequel features.
The sequel is a single-player survival-horror game. Cross-platform multiplayer is not relevant because no multiplayer mode is listed on the official product information.
Buying the correct edition
Use the official sequel link and compare Standard, Deluxe, and Premium content before purchase. Regional pricing and promotions can change, so the Xbox checkout page is the authority for the buyer's currency.
No confirmed physical Xbox disc appears in the sources checked for this guide. The current official listing should be treated as a digital product unless Frogwares announces a boxed edition separately.
Sources
Facts were rewritten in original English and checked against the following pages. Store values can change after this snapshot.