Sub-panels are sized based on the calculations of feeder load which is based on the calculations of branch circuit loads.
There is no "one" answer for your question as far as how big can it be.
If you have a 125A main panel with 30 circuits and you need a sub-panel, you would install the size needed based on current load and then room for expansion.