No,you do not have to upgrade to 6.5.
The minimum requirements for 6.5 are as follows:
1) 512 meg RAM ,it will not install with anything less.
2) a SYS volume of of 2 to 4 gigabytes
3) an Intel Pentium or AMD Athlon(no K6 allowed)
5.1 is more forgiving,but there will be issues such as backup software and other 3rd party programs.
Depending upon the number of users ,you might be better off going to the Novell Small Business server product (50 users or less for SBS 5.1 or 100 users or less for SBS 6.5)
SBS 6.5 gives you:
Zenworks
2 Node Clustering
Ifolder
Groupwise
Apache Webserver
My SQL database
NDPS/Iprint
Backup Software
Virtual Office
2nd server that you can add to tree
plus you can add xtra servers and nodes to a cluster
Branch manager (File and print appliance for satillite offices)
BorderManager
DirXML (If you have a Windows domain ,you can sync users and passwords through EDIR
iSCSI support
SBS 5.1 gives you many of the same features as above just some of the features are lower rev(Zen 3.2 instead of 4.01),no clustering ,and a limit of one server in the tree.
The cost is about the same to upgrade to 5.1 or 6.5.
As for an inplace upgrade,I don't like them .You would be better off doing a migration to another server.