sed help adding parenthesis

I have the following data and want to put parenthis around the numbers:

 
PARTITION PERIOD_MIN   VALUES LESS THAN 10649 TABLESPACE ODS_DAILY_MF_AUM,
 PARTITION PERIOD_10649 VALUES LESS THAN 10650 TABLESPACE ODS_DAILY_MF_AUM,
 PARTITION PERIOD_10650 VALUES LESS THAN 10651 TABLESPACE ODS_DAILY_MF_AUM,
...
...
...

The output should look like this

 
PARTITION PERIOD_MIN   VALUES LESS THAN (10649) TABLESPACE ODS_DAILY_MF_AUM,
 PARTITION PERIOD_10649 VALUES LESS THAN (10650) TABLESPACE ODS_DAILY_MF_AUM,
 PARTITION PERIOD_10650 VALUES LESS THAN 1(0651)TABLESPACE ODS_DAILY_MF_AUM,
...
...
...

Can somebody provide me with a SED or AWK statement that can do this in one shot.

Thanks to all who answer

awk '{$(NF-2)="("$(NF-2)")"}1' file

Try also

sed -r 's/ ([0-9]+) / (\1) /' file
PARTITION PERIOD_MIN   VALUES LESS THAN (10649) TABLESPACE ODS_DAILY_MF_AUM,
 PARTITION PERIOD_10649 VALUES LESS THAN (10650) TABLESPACE ODS_DAILY_MF_AUM,
 PARTITION PERIOD_10650 VALUES LESS THAN (10651) TABLESPACE ODS_DAILY_MF_AUM,