Thanks. In "Automatic", the displayed speed is what you actually attain.
There is a component in your Ethernet link limiting its speed. You need to determine what it is. Router, switches, surge suppressors, links... etc. Methodically eliminate each one of those possibilities and you will find the culprit, and don't overlook the Ethernet cable either. Substitute another one. All eight conductors have to be intact end to end, all connectors have to be intact... etc.
Automatic negotiation operates on two of the four pairs of conductors. If the maximum attainable speed is 1000Base-T then the link requires all four pairs of conductors to be operable. If only two pair are available, then either your Mac or the device at its other end will conclude the link is insufficient and fall back to the next fastest speed. In your case that's 100Base-T.
When you changed its configuration to "Manual" and specified 1000BaseT, your Mac was deprived of the ability to perform that automatic negotiation, forcing it to use all four pairs. It has concluded at least one of those eight conductors simply isn't there. That's why Network Preferences indicates "Cable Unplugged". As far as your Mac is concerned it might as well be.