[C-API] Expose SyncUser::subscribe()

[nirinchev]

This is a stopgap for #6516 - we have customers requesting that information for flutter, so until we can get more fine-grained notifications, we should at least expose the "user has changed" notifications.